package com.yt.dor.mapper;

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.yt.dor.models.dto.DormBedDTO;
import com.yt.dor.models.vo.DormBedVO;

import java.util.List;

/**
 * 宿舍床位表详情映射
 *
 * @author thekai
 * @Date 2025-10-21 14:11:59
 */
public interface DormBedMapper extends BaseMapper<DormBedDTO> {
    List<DormBedVO> query();

    DormBedDTO selectAvailableBedByRoomId(Long id);

    List<Long> selectStudentProfessionsInRoom(Long id);

    int countOccupiedBedsByRoomId(Long id);

    List<DormBedVO> selectUnallocatedBeds();
}
